Introduction

• Many people are interested to know about the tuition, costs, diversity and potential salary when searching for college.
• In this project, we want to analyze:

1. Diversity among schools across US
2. Tuition costs across different states
3. Historical trends of tuition
4. Average potential salary for graduates from different universities

• We have 4 datasets with 23 variables and more than 50000 observations.

Diversity dataset

diversity_school %>% glimpse()

Diversity dataset

diversity_school %>% glimpse()

## Rows: 50,655
## Columns: 5
## $ name             <chr> "University of Phoenix-Arizona", "University of Phoe…
## $ total_enrollment <dbl> 195059, 195059, 195059, 195059, 195059, 195059, 1950…
## $ state            <chr> "Arizona", "Arizona", "Arizona", "Arizona", "Arizona…
## $ category         <chr> "Women", "American Indian / Alaska Native", "Asian",…
## $ enrollment       <dbl> 134722, 876, 1959, 31455, 13984, 1019, 58209, 19039,…

Bar chart of all diversity categories and ethnicity groups in the US colledge

Bar chart of all diversity categories and ethnicity groups in the US colledge

Finding the most diverse campus for each diversity category

Finding the most diverse campus for each diversity category

Diversity map of the US for each diversity group

Women enrollment rate across the US

Tuition cost dataset

tuition_cost %>% glimpse()

Finding the most diverse campus for each diversity category

Diversity map of the US for each diversity group

Women enrollment rate across the US

Tuition cost dataset

tuition_cost %>% glimpse()

## Rows: 2,973
## Columns: 10
## $ name                 <chr> "Aaniiih Nakoda College", "Abilene Christian Uni…
## $ state                <chr> "Montana", "Texas", "Georgia", "Minnesota", "Cal…
## $ state_code           <chr> "MT", "TX", "GA", "MN", "CA", "CO", "NY", "NY", …
## $ type                 <chr> "Public", "Private", "Public", "For Profit", "Fo…
## $ degree_length        <chr> "2 Year", "4 Year", "2 Year", "2 Year", "4 Year"…
## $ room_and_board       <dbl> NA, 10350, 8474, NA, 16648, 8782, 16030, 11660, …
## $ in_state_tuition     <dbl> 2380, 34850, 4128, 17661, 27810, 9440, 38660, 53…
## $ in_state_total       <dbl> 2380, 45200, 12602, 17661, 44458, 18222, 54690, …
## $ out_of_state_tuition <dbl> 2380, 34850, 12550, 17661, 27810, 20456, 38660, …
## $ out_of_state_total   <dbl> 2380, 45200, 21024, 17661, 44458, 29238, 54690, …

Merge tuition cost dataset and diversity dataset

• We are interested to know whether there is any correlation between enrollment rate and each diversity group
• We have done analysis for both in state and out of state tuition in the next slides

Relationship between enrollment rate and in-state-tuition per each diversity group

Relationship between enrollment rate and out-of-state tuition per each diversity group

Relationship between enrollment rate and in-state-tuition per each diversity group

Relationship between enrollment rate and out-of-state tuition per each diversity group

Relationship between diversity groups enrollment rate and early career salary

• we need to merge diversity dataset and salary dataset.

Different types of colleges in US

How many colleges are there in each state?

Comparing different states in terms of in state and out of state tuition

Comparing in/out-of state tuition

In-state tuition, different type of colleges; What is the relationship?

Out-of-state tuition, different type of colleges; What is the relationship?

The chepeast/most expensive colleges with out-of-state tuition

The cheapest/most expensive colleges with in-state tuition

Different types of colleges in US

How many colleges are there in each state?

Comparing different states in terms of in state and out of state tuition

Comparing in/out-of state tuition

In-state tuition, different type of colleges; What is the relationship?

Out-of-state tuition, different type of colleges; What is the relationship?

The chepeast/most expensive colleges with out-of-state tuition

The cheapest/most expensive colleges with in-state tuition

The historical tuition dataset

270 observations and 4 variables

The historical tuition dataset

We observe that the data is available consistantly from 2000 till 2017.

##  [1] "1985-86" "1995-96" "2000-01" "2001-02" "2002-03" "2003-04" "2004-05"
##  [8] "2005-06" "2006-07" "2007-08" "2008-09" "2009-10" "2010-11" "2011-12"
## [15] "2012-13" "2013-14" "2014-15" "2015-16" "2016-17"

For convinience, we will consider the end of year.

##  [1] 1986 1996 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
## [16] 2014 2015 2016 2017

Average tuition cost over time

Tuition comparison between 2 year and 4 year programs

Average tuition cost over time

Tuition comparison between 2 year and 4 year programs

Salary potential dataset

935 observations and 6 variables including:

Which states have the highest/least potential salary?

Which states have the highest/least potential salary?

Top 5 states

Let’s take a closer look at Iowa

In Iowa, ISU has the highest potential salary

What is average stem percent across different states?

In Iowa, ISU has the highest potential salary

What is average stem percent across different states?

Conclusions

• The map of diversity across the US indicates that the US colleges are not equally diverse geographically.
• There is relationship between different diversity groups, tuition and early career salary.
• Average out-of-state tuition differs across the country while average in-state tuition remains almost the same.
• East coast colleges are more expensive in terms of in-state and out-of-state tuition.
  
• Massachusetts has the highest in-state tuition.
• Private schools cost more than public schools.
• Historical trend of tuition showed that tuition is increasing over time.
• Universities located in west/east coast have higher stem percent and also higher potential salary.